package com.zr.planclass.mapper;


import com.zr.planclass.pojo.PlanClassAddVo;
import com.zr.planclass.pojo.PlanClassSelectVo;
import com.zr.planclass.pojo.PlanClassVo;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface PlanClassMapper {

    
    @Insert("insert into planclass (name,code,remark,status) values (#{name},#{code},#{remark},#{status})")
    void addPlanClass(PlanClassVo planClassVo);

    @Select("select * from planclass where id=#{id}")
    PlanClassVo queryById(Integer id);

    @Update("update planclass set name=#{name},status=#{status},updateName=#{updateName} where id=#{id}")
    void updatePlanClass(PlanClassVo planClassVo);

    @Update("update planclass set status=#{status},updateName=#{updateName} where id=#{id}")
    void updatePlanClassStatus(PlanClassVo planClassVo);

    List<PlanClassVo> queryPageData(PlanClassSelectVo planClassSelectVo);

    int queryPageCount(PlanClassSelectVo planClassSelectVo);

    void insert(List<PlanClassAddVo> planClassAddVoList);


    List<String> queryByName(List<String> nameList);

    List<String> queryByCode(List<String> codeList);

    List<PlanClassVo> exportMater(PlanClassSelectVo planClassSelectVo);
}
